Exploiting Versions for On-line Data Warehouse Maintenance in MOLAP Servers
نویسندگان
چکیده
A data warehouse is an integrated database whose data is collected from several data sources, and supports on-line analytical processing (OLAP). Typically, a query to the data warehouse tends to be complex and involves a large volume of data. To keep the data at the warehouse consistent with the source data, changes to the data sources should be propagated to the data warehouse periodically. Because the propagation of the changes (maintenance) is batch processing, it takes long time. Since both query transactions and maintenance transactions are long and involve large volumes of data, traditional concurrency control mechanisms such as two-phase locking are not adequate for a data warehouse environment. We propose a multi-version concurrency control mechanism suited for data warehouses which use multi-dimensional OLAP (MOLAP) servers. We call the mechanism multiversion concurrency control for data warehouses (MVCCDW). To our knowledge, our work is the first attempt to exploit versions for online data warehouse maintenance in a MOLAP environment. MVCC-DW guarantees the serializability of concurrent transactions. Transactions running under the mechanism do not block each other and do not need to place locks. Permission to copy without fee all or part of this material is granted provided that the copies are not made or distributed for direct commercial advantage, the VLDB copyright notice and the title of the publication and its date appear, and notice is given that copying is by permission of the Very Large Data Base Endowment. To copy otherwise, or to republish, requires a fee and/or special permission from the Endowment. Proceedings of the 28th VLDB Conference, Hong Kong, China, 2002
منابع مشابه
Maintaining Temporal Warehouse Models
DWT is a tool for the maintenance of data warehouse structures based on the temporal data warehouse model COMET. Data warehouse systems do not provide support for maintaining changes in dimension data. DWT allows keeping track of modifications made in the dimension-structure of multidimensional cubes stored in an OLAP (On-Line Analytical Processing) system. We present the overall structure of t...
متن کاملExploiting Temporal Correlation in Temporal Data Warehouses
Data is typically incorporated in a data warehouse in increasing order of time. Furthermore, the MOLAP data cube tends to be sparse because of the large cardinality of the time dimension. We propose an approach to improve the efficiency of range aggregate queries on MOLAP data cubes in a temporal data warehouse by factoring out the time-related dimensions. These time-related dimensions are hand...
متن کاملCSM - A Maintenance Tool for Data Warehouse Structures
CoSM (Comet Structure Manager) is a tool for the maintenance of data warehouse structures based on the temporal data warehouse model COMET. Current data warehouse systems do not care for changes in dimension data. CoSM allows keeping track of modifications made in the dimension-structure of multidimensional cubes stored in an OLAP (On-Line Analytical Processing) system. CoSM can download dimens...
متن کاملAggregated Biomedical-Information Browser (ABB): A Graphical User Interface for Clinicians and Scientists to Access a Clinical Data Warehouse
Abbreviations: ABB: Aggregated Biomedical-information Browser; OLAP: On-Line Analytical Processing; DW4TRL: Data Warehouse for Translational Research; MOLAP: Multidimensional On-Line Analytical Processing; CBCP: Clinical Breast Care Project; IRB: Institutional Review Board; EAV: Entity Attribute Value; ISIV: Individual Subject Information Viewer; BMI: Body Mass Index; ER: Estrogen Receptor; PR:...
متن کاملOn the Performance of an Array-Based ADT for OLAP Workloads
There is currently a debate among OLAP vendors on the best way to provide OLAP functionality: Relational OLAP (ROLAP) vendors advocate using sophisticated front ends to provide a multidimensional view of a standard relational database, whereas Multidimensional OLAP (MOLAP) vendors provide custom servers that generally store their data as arrays (instead of tables.) An important question in this...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
عنوان ژورنال:
دوره شماره
صفحات -
تاریخ انتشار 2002